If passwords are used for authentication, the EDB Postgres Advanced Server must store only hashed, salted representations of passwords.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-259247	EPAS-00-004300	SV-259247r938794_rule		High

Description

The DOD standard for authentication is DOD-approved PKI certificates. Authentication based on User ID and Password may be used only when it is not possible to employ a PKI certificate, and requires AO approval. In such cases, database passwords stored in clear text, using reversible encryption, or using unsalted hashes would be vulnerable to unauthorized disclosure. Database passwords must always be in the form of one-way, salted hashes when stored internally or externally to the DBMS.

STIG	Date
EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide	2023-11-20

Details

Check Text ( C-62986r938792_chk )
Execute the following SQL as the "enterprisedb" user: SHOW password_encryption; If the value is not "scram-sha-256", this is a finding

Fix Text (F-62895r938793_fix)
Execute the following SQL as the "enterprisedb" user: ALTER SYSTEM SET password_encryption = 'scram-sha-256'; SELECT pg_reload_conf();